[TechTarget Chinese original] Q: I am studying various types of database architectures. Can you tell me the security of non-SQL databases (NoSQL) and mainstream commercial relational databases?
For a database that stores information securely, it must provide confidentiality, integrity, and availability (CIA ). When necessary, data must be available (availability
premise, the overhead of data update is very small (the same field basically only has one)
3. complex queries such as Join operations can be performed (Join operations cannot be performed between different servers)
4. There are many practical achievements and professional technical information (mature technologies)
5. All data is expressed in the binary representation of rows and columns, which makes it easier to understand and understand.
Lack of relational
information query, may be random, and the news query is based on time, the more new more frequent.NoSQL and relational database combinationIn fact, NoSQL database is only a relational database in some aspects (performance, expansion) of a make up, single-function, NoSQL almost all the functions, in the relational database can be satisfied, so the choice of NoSQL
Abstract: Although SQL database is a very useful tool, after 15 years of outstanding performance, the monopoly will be broken. This is only a matter of time: I was forced to use relational databases, but I finally found that I could not meet my needs. For details, see my IT-Homer blog: Comparison of eight mainstream NoSQL dat
What is the comparison between nosql and relational databases?
Advantages:
1) Cost: nosql databases are simple and easy to deploy. They are basically open-source software and do not need to be purchased and used at the same cost as Oracle, which is cheaper than relationa
Recently, the company is making a NoSQL model selection, and has made the following Rough Analysis and Comparison on several common NoSQL databases over a week.
Recently, the company is making a NoSQL model selection, and has made the following Rough Analysis and
The difference between NoSQL and NoSQL is much greater than the difference between different SQL databases. Therefore, software architects must select a suitable NoSQL from the very beginning of the project.
The difference between NoSQL and
Random access performance comparable to MySQL
Best practice scenario: for Preference BigTable:) and for random, real-time access to big data.For example: Facebook message database (more common use cases are about to appear)Note 4:thrift is an interface definition language that provides definition and creation services for a variety of other languages, developed by Facebook and open source.Of course, all systems do not only have these features listed above. Here I just list some of the
may encounter. In fact, mongodb installation is relatively simple.
With the rise of Internet Web websites, traditional relational databases are insufficient in Hong Kong Space.
High-concurrency database read/write requirements
High concurrent database load, website space, tens of thousands of read/write requests per second, disk I/O bottleneck
High-efficiency access to massive data
Efficient query of hundreds of millions or even billions of records
H
We are going to perform a simple test on reading and writing MongoDB, Redis, and Tokyo Tyrant. To perform a fair test, we need to understand the implementation mechanism behind them. Below are some comparisons:Comparison of storage implementation:* Memory File Image (Memory-File Mapping) Redis, MongoDB* File + Cache Tokyo Tyrant* Memory: Redis, Tokyo TyrantKey/Value index format:* B + Tree: MongoDB, Tokyo Tyrant* Hash Table: Redis, Tokyo Tyrant* Fixed Length: Tokyo TyrantFrom the above
Source: comparison of various nosql databases in http://hi.baidu.com/eastdoor/blog/item/758d0e3eedb5d92471cf6c14.html Cassandra, MongoDB, CouchDB, Redis, Riak, HBaseCouchDBDevelopment language: ErlangMain advantages: data consistency and ease of useLicense: ApacheProtocol: HTTP/RESTApplicable: accumulated, less changed data. Or a large number of versions are requ
Key-Value Store databaseTemporary: as memcached. The temporary key-value database stores the data in memory, which in two cases results in the loss of data, the first is the power outage, but the data content exceeds the memory size. The benefits of this treatment are very fast.Permanent type: such as Tokyo Tyrant, flare and RomaThe two are both types: Redis. Redis first data in memory, and then meet certain conditions (the default is 15 minutes more than 1 times, 5 minutes more than 10, 11 minu
The top 10 SQL and NoSQL databases in the latest statistics, and nosql databases in the latest statistics
This ranking is based on the ranking of DB Engines, which analyzes the popularity of 200 different databases on the market. The Top 10
What is nosql?
Nosql (nosql = not only SQL) means not only SQL expansion, but also non-relational databases.
With the rise of Internet Web websites, traditional relational databases are dealing with Web websites, especially ultra-large-scale and high-concurrency SNS type
relational databases and NoSQL databases what is NoSQLHave you ever heard of "NoSQL"? In recent years, this word has been of great concern. To see the word "NoSQL," you might mistakenly think it was "no! SQL "abbreviation, and deeply outraged:" How can SQL be unnecessary? "
data can be written to a node as soon as possible without being delayed by the network transmission. The disadvantage is that consistency is not always guaranteed, and a small amount of data may be lost in the event of a failure.
The RDBMS adheres to the acid principle, and NoSQL has the base principle , which conforms to the CP in the CAP, which conforms to the AP in the CAP (that is, the former sacrifices availability, the latter sacrifices con
Detailed description of distributed algorithms and NoSQL algorithms in nosql Databases
Today, we will study some distributed strategies, such as replication in fault detection. These strategies are marked in italics and divided into three parts:
Data consistency. NoSQL requires a balance between consistency, fault t
different grammatical nuances.
NoSQL databases use javascript like the JOSN parameter to query! The basic operations are the same, but nested JOSN will produce complex queries.
Comparison:
SQL
NoSQL
Insert a new book record
INSERT INTO book (I
NoSQL databases: data consistency, nosql Database ConsistencyNoSQL Database: Data ConsistencyRead consistency
High ConsistencyAccess any node in the cluster at any time, and the data obtained is consistent;
User consistency is consistent with the data obtained during cluster access for the same user;Solve user consistency: Use a sticky session to bind the sess
database, allowing for the nesting of key values. and the document database is more efficient than the key-value database query. such as: CouchDB, MongoDb. Domestic also has the document type database SEQUOIADB, already open source.4. Graph Database (graph)The graphical structure of the database is different from the other columns and the rigid structure of the SQL database, it is using a flexible graphical model, and can be extended to multiple servers. No
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.